One maxim I was taught early on in Notes Administration (back in 1995) is "Thou shalt not install non-Notes related software on your notes server".

Also, doing so would require the notes server have at least access to some other network drive onto which it would deposit the output file. (God forbid we should expose a drive on the notes server to public use.)

Anyway, in my case, I'm just a developer at this company. There's no way the administrators would permit that so it's not an option.

It's odd Barry that my post appears before yours (which is what I was replying to....) Our office isn't equipped with a time machine......

Install excel on the server

1. Any agent that is running in foreground already, is running in foreground.

2. Any agent invoked by agent.Run(), the calling agent waits for the agent to complete.

I'm focusing on the agent that's asking the question whether to run in background. It's probably running in foreground. And it's invoking agent.Run(). And it's waiting for the agent to complete.

If you're really interested in providing both options & running this agent in a background thread, launch it from a formula agent with @PostedCommand().

One more caveat, though.

COM operations can lock up your workstation while they work. While it's possible to minimize the hiccupping & shuddering, and while Excel is actually a master of minimizing this, it still happens, and you'll need to shut off a lot of foreground refreshes *in Excel* to make it happen.

Thanks Mike! That's what I was looking for. I even got by the problem of passing the UNID by using environment variables (which I think in this case is a better solution)

It's sort of wierd. While it's running, I have full mobility within Notes, but my print statements from the routine are showing up on the message bar rather than my logfile as I expected. (Not complaining though)

Wonder if they'll ever add a [NoWait] option to the lotusScript agent.run statement.

(Would be nice, wouldn't it.)